package com.comtop.topcloud.device.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.comtop.topcloud.device.model.mysql.EnergyEquipmentMonitorRefTag;
import org.apache.ibatis.annotations.Select;

public interface EnergyEquipmentMonitorRefTagMapper extends BaseMapper<EnergyEquipmentMonitorRefTag> {

  @Select("SELECT * " +
           "    FROM energy_equipment_monitor_ref_tags " +
           "    WHERE serial_number = #{serialNumber} " +
           "    AND tag_name = #{tagName} " +
           "    AND monitor_name = #{monitorName}  limit 1  ;")
  EnergyEquipmentMonitorRefTag getEquipmentMonitorRefTag(String serialNumber, String monitorName , String tagName);



}
